Job Overview
We are seeking a highly skilled Senior Database Administrator to join our dynamic team in a remote capacity. In this pivotal role, you will be instrumental in the administration, support, and implementation of both existing and new SQL systems, data conversions, and migrations. Your expertise will be essential in overseeing Transact-SQL reviews, database change deployments, and system monitoring, particularly during migrations to new platforms. This position requires a proactive approach to ensure the availability and performance of several core systems, alongside developing and testing disaster recovery plans.
Key Responsibilities
- Ensure system availability and implement effective recovery protocols.
- Execute performance tuning, backup, and restoration processes for databases.
- Manage the daily operations of the Microsoft SQL Server infrastructure, ensuring optimal service availability.
- Maintain databases across Development, QA, and Production environments.
- Troubleshoot and optimize database performance while addressing any issues that arise.
- Implement stringent security measures to uphold data integrity.
- Collaborate with business users, developers, and infrastructure teams to deliver high-quality solutions.
- Document database maintenance procedures for future reference.
- Uphold policies and procedures to ensure compliance with regulatory standards.
- Update SQL servers with necessary patches and release application database changes to production environments.
- Conduct server migration and upgrade activities.
- Perform additional duties as required.
Required Skills
- A minimum of 5 years of experience in database administration within complex production SQL Server environments.
- Proficient knowledge of Microsoft SQL Server 2014⁄2016 or later versions.
- Strong understanding of relational databases, T-SQL scripting, and database normalization best practices.
- Proven hands-on experience in troubleshooting and resolving database integrity and performance issues in production settings.
- Exceptional skills in performance tuning and query optimization.
- Familiarity with SQL Server in Azure, including Azure SQL Database and SQL on Azure VM.
- Proficient in SQL development, with the ability to write and troubleshoot SQL code, design stored procedures, functions, tables, views, triggers, indexes, and constraints.
- Experience in database design within a software development environment.
Qualifications
- Bachelor’s degree in Computer Science or a related field, or equivalent experience.
- Practical experience migrating SQL Server to Microsoft Azure is advantageous.
- Experience with establishing, configuring, and maintaining SQL Server AlwaysOn high availability is preferred.
- Knowledge of Service Broker, SSRS, SSIS, or SSAS is a plus.
Career Growth Opportunities
We are committed to fostering a culture of continuous learning and professional development. As part of our team, you will have access to resources that encourage skill enhancement and career advancement within the organization.
Compensation And Benefits
The salary range for this position is \(94,745 - \)159,206, determined by various factors such as location, skills, experience, qualifications, and market conditions. Adjustments to the salary range may occur based on evaluations during the interview process.
We offer a comprehensive benefits package for full-time employees, including medical, dental, and vision insurance, long-term disability, life insurance, health savings accounts, flexible spending accounts, paid time off, and a 401(k) plan with traditional and Roth options.
Equal Opportunity Employer
Our organization is dedicated to creating an inclusive and diverse workplace. We are an equal opportunity employer and maintain a drug-free environment, in compliance with applicable ADA regulations.
Employment Type: Full-Time